Tabela PhStDocAccountDef

Definicja tabeli PhStDocAccountDef

Name

PhStDocAccountDef

Code

PhStDocAccountDef

Comment

Definicje kont


Lista kolumn tabeli PhStDocAccountDef

Name

Code

StDocAccountDefId

StDocAccountDefId

StDocKindID

StDocKindID

StDocTypeID

StDocTypeID

AccountDebitDef

AccountDebitDef

AccountCreditDef

AccountCreditDef

FromDt

FromDt

ToDt

ToDt

Active

Active

LotTypeId

LotTypeId

StId

StId

reverseSign

reverseSign

Registry

Registry


Kolumna StDocAccountDefId tabeli PhStDocAccountDef

Definicja kolumny StDocAccountDefId tabeli PhStDocAccountDef

Name

StDocAccountDefId

Code

StDocAccountDefId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StDocKindID tabeli PhStDocAccountDef

Definicja kolumny StDocKindID tabeli PhStDocAccountDef

Name

StDocKindID

Code

StDocKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StDocTypeID tabeli PhStDocAccountDef

Definicja kolumny StDocTypeID tabeli PhStDocAccountDef

Name

StDocTypeID

Code

StDocTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AccountDebitDef tabeli PhStDocAccountDef

Definicja kolumny AccountDebitDef tabeli PhStDocAccountDef

Name

AccountDebitDef

Code

AccountDebitDef

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

Definicja konta winien


Kolumna AccountCreditDef tabeli PhStDocAccountDef

Definicja kolumny AccountCreditDef tabeli PhStDocAccountDef

Name

AccountCreditDef

Code

AccountCreditDef

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

Definicja konta ma


Kolumna FromDt tabeli PhStDocAccountDef

Definicja kolumny FromDt tabeli PhStDocAccountDef

Name

FromDt

Code

FromDt

Data Type

DATE

Mandatory

No

Comment

Data obowiazywania od


Kolumna ToDt tabeli PhStDocAccountDef

Definicja kolumny ToDt tabeli PhStDocAccountDef

Name

ToDt

Code

ToDt

Data Type

DATE

Mandatory

No

Comment

Data obowiazywania do


Kolumna Active tabeli PhStDocAccountDef

Definicja kolumny Active tabeli PhStDocAccountDef

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna LotTypeId tabeli PhStDocAccountDef

Definicja kolumny LotTypeId tabeli PhStDocAccountDef

Name

LotTypeId

Code

LotTypeId

Data Type

NUMBER(10)

Mandatory

No

Comment

klucz obcy do tabeli PhLotTypeId - rózne ksiegowania dla
typu dostawy


Kolumna StId tabeli PhStDocAccountDef

Definicja kolumny StId tabeli PhStDocAccountDef

Name

StId

Code

StId

Data Type

NUMBER(10)

Mandatory

No

Comment

klucz obcy do tabeli PhSt - rózne ksiegowania dla róznych
magazynów


Kolumna reverseSign tabeli PhStDocAccountDef

Definicja kolumny reverseSign tabeli PhStDocAccountDef

Name

reverseSign

Code

reverseSign

Data Type

NUMBER(1)

Mandatory

Yes

Comment

 


Kolumna Registry tabeli PhStDocAccountDef

Definicja kolumny Registry tabeli PhStDocAccountDef

Name

Registry

Code

Registry

Data Type

VARCHAR2(8)

Mandatory

No

Comment

Kolumna przechowuje informacje o rejestrze ksiegowym


Lista kluczy tabeli PhStDocAccountDef

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhStDocAccountDef

Definicja klucza Identifier_1 tabeli PhStDocAccountDef

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment